SELECT *, CASE WHEN `name` LIKE "jericho%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "jericho" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "jericho" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "jericho" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("jericho") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
$1,588,00059 Saratoga DrJericho NY 11753View Listing
$1,550,00012 Herkimer AveJericho NY 11753View Listing
$1,500,00077 Bounty LnJericho NY 11753View Listing
$1,498,00034 Hightop LnJericho NY 11753View Listing
$1,498,000194 Birchwood Park DrJericho NY 11753View Listing
$1,425,5007 Schuyler DrJericho NY 11753View Listing
$1,399,88837 Maiden LnJericho NY 11753View Listing
$1,399,000400 Madison PlJericho NY 11753View Listing
$1,350,00015 Delaware AveJericho NY 11753View Listing
$1,299,00014 Sagamore Way SJericho NY 11753View Listing
$1,299,00084 Hunt Dr Unit 84Jericho NY 11753View Listing
$1,288,000115 Orleans LnJericho NY 11753View Listing
$1,288,00011 Sullivan DrJericho NY 11753View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 12:27:55 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah